Ideal Strategy to Improve Datawarehouse Performance

نویسنده

  • Fahad Sultan
چکیده

Data warehouse is set up for the benefits of business analysts and executives across all functional areas. The primary goal of data warehouse is to free the information locked up in the operational database so that decision makers and business analyst can make queries, analysis and planning regardless of the data changes in operational database. Data analysis in a large database requires some innovative techniques; there should be some new methods and procedures to look at the data with different angles. While executing adhoc queries over a large database degrade the query performance at considerable level because query will have to go through from large volume of data after making lot of joins. Moreover, as the number of queries is large, therefore, in certain cases there is reasonable probability that same query submitted by the one or multiple users at different times. Each time when query is executed, all the data of warehouse is analyzed to generate the result of that query. In this paper we purpose an ideal approach which definitely minimizes response time and improves the efficiency of data warehouse overall, particularly when data warehouse is updated at regular interval. This approach has been validated by Formal Method. Keywords-Data Warehouse; Perfomance; Formal Method

برای دانلود رایگان متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

Using contingency approach to improve firms’ financial performance forecasts

One of the challenging issues for investors and professionals is appropriate models to evaluate financial situation of the firms. In this regard, many models have been extracted by researchers using different financial ratios to resolve these issues. However, choosing a model based on the conditions and users’ needs is complex. The main objective of this study is to identify the effect of conti...

متن کامل

The Evaluation method of HVAC System’s operation performance based on Energy Flow Analysis and DEA

An energy flow model of an airport terminal’s HVAC system is established in this paper. Based on energy flow model, the exergy efficiency, exergy loss and exergy cost distribution ratio of each component are calculated and analyzed by the energy flow model. Optimization method and exergy balance equations are used to calculate the lowest exergy loss of HVAC system under different operation cond...

متن کامل

A survey of query recommendation techniques for data warehouse exploration

Lots of data are gathered in datawarehouses that are navigated and explored for analytical purposes. Only recently has the problem of recommending a datawarehouse query to a datawarehouse user attracted attention. In this paper, we propose a simple formal framework for expressing datawarehouse query recommendations. We propose to see the problem of recommending a datawarehouse query for explora...

متن کامل

Multidimensional Datawarehouse with Combination Formula

Spits Warnars Harco Leslie Hendric (BLLES) Budi Luhur Learning Solution Budi Luhur University Jl. Petukangan Utara, Kebayoran Lama, Jakarta Selatan 12260, Indonesia [email protected] ABSTRACT Multidimensional in data warehouse is a compulsion and become the most important for information delivery, without multidimensional datawarehouse is incomplete. Multidimensional give the able to analyze busin...

متن کامل

DESIGN AND DEVELOPMENT OF THE STRATEGY TO IMPROVE PATIENT SATISFACTION IN A HOSPITAL SETTING

Attempts made ​​in order to improve management tools of performance showing the importance of customer satisfaction in determining the organizations’ success in profitability and business. The main objective of this study was to develop appropriate strategies to improve patient satisfaction in Hospital.   The research was a descriptive-practical one. Data was collected through a brainstorming...

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

عنوان ژورنال:

دوره   شماره 

صفحات  -

تاریخ انتشار 2010